How to use mysql transaction within multiple related functions